|
�
In order to create the query use the menu path Environment => Queries
�
Give a name to the query and click on the Create button
�
Give the description of the query in the next screen. Specify the output
length and select the processing option from the Further Processing Options
box. The data can be displayed in various formats such as table, download to
a file, and display in Word etc.
�
Click on the Next screen icon. Select the functional group screen. All the
functional groups created in the functional area are displayed. Select the
groups that you desire � fields from only these groups will be displayed in
the output. Click on the respective check boxes and click on the Next Screen
icon.
�
The Select Field screen gets displayed. Select all the fields from the user
group that you need to display on the output of the query. If required,
specify the short names for the fields using the menu path Edit => Short
Names => Switch On/Off or you can also change the selection text contains in
the order you want to appear on the selection screen. You can also maintain
column headers for the fields by using the menu path Edit => Column Header
=> Maintain.
�
Click on the Next Screen icon to get the Selections Screen. Here you can
check against the fields that you require to be shown on the selection
screen.
�
Now we need to specify the output type for the query as Basic List,
Statistics or Ranked List. Choose the option Basic List.
�
On the Basic List line structure screen the following things can be done
o
Specify the report layout in detail � lines on which the fields will appear.
o
Order in which the fields will appear in the output
o
Sort order for the fields � this is optional.
o
For the numeric fields you can check against the fields for which you
require totals in the output.
o
Beautify the output according to the options provided.
�
Click on the next screen icon, to specify the control levels as mentioned
below
o
Specify the sort order. The default sort order is ascending and can be
changed to descending if required.
o
Totals for each field selected for sorting can be displayed
o
To display the output of a field in a box click on the check box against
box. To display a line after the output of a field, click on the check box
against BlnkLn
o
To display the output of a field on a new page click on the check box
against New Page
�
Click on the next screen icon to get the List Line options Screen. Here you
can specify the background color for displaying the output.
�
Click on the next screen icon to get the Field Output Option screen. In this
you can specify the following:
o
Change the output length or the display positions of the fields
o
Specify the display position of the unit for quantity or currency fields.
Click left radio button to display it before the figure, middle radio button
to display it after the figure while last radio button to hide the unit
altogether.
o
Specify color for the column of every field under the Format option.
o
Specify the label against the output of sort fields.
�
Click on the Next screen option to go to the Basic List Header screen. Here
you can specify
o
Give page header and page footer for the output
o
Include user name and date by specifying &N and &D respectively.
After providing all the above options you can
save the query and execute it by clicking the Execute button twice.
|
